<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>Send a FrontBase query</title>
 </head>
 <body class="docs"><div id="layout">
  <div id="layout-content"><div id="function.fbsql-query" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">fbsql_query</h1>
  <p class="verinfo">(PHP 4 &gt;= 4.0.6, PHP 5, PHP 7)</p><p class="refpurpose"><span class="refname">fbsql_query</span> &mdash; <span class="dc-title">Send a FrontBase query</span></p>

 </div>
 
 <div class="refsect1 description" id="refsect1-function.fbsql-query-description">
  <h3 class="title">说明</h3>
  <div class="methodsynopsis dc-description">
   <span class="methodname"><strong>fbsql_query</strong></span>
    ( <span class="methodparam"><span class="type">string</span> <code class="parameter">$query</code></span>
   [, <span class="methodparam"><span class="type">resource</span> <code class="parameter">$link_identifier</code></span>
   [, <span class="methodparam"><span class="type">int</span> <code class="parameter">$batch_size</code></span>
  ]] ) : <span class="type">resource</span></div>

  <p class="para rdfs-comment">
   Sends a <code class="parameter">query</code> to the currently active database on
   the server.
  </p>
  <p class="para">
   If the query succeeds, you can call <span class="function"><a href="fbsql_num_rows.html" class="function">fbsql_num_rows()</a></span> to
   find out how many rows were returned for a SELECT statement or
   <span class="function"><a href="fbsql_affected_rows.html" class="function">fbsql_affected_rows()</a></span> to find out how many rows were
   affected by a DELETE, INSERT, REPLACE, or UPDATE statement.
  </p>
 </div>


 <div class="refsect1 parameters" id="refsect1-function.fbsql-query-parameters">
  <h3 class="title">参数</h3>
  <p class="para">
   <dl>

    
     <dt>
<code class="parameter">query</code></dt>

     <dd>

      <p class="para">
       The SQL query to be executed.
      </p>
      <blockquote class="note"><p><strong class="note">Note</strong>: 
       <p class="para">
        The query string shall always end with a semicolon.
       </p>
      </p></blockquote>
     </dd>

    
    <dt>
<code class="parameter">
link_identifier</code></dt>
<dd>
<p class="para">由
<span class="function"><a href="fbsql_connect.html" class="function">fbsql_connect()</a></span> 或
<span class="function"><a href="fbsql_pconnect.html" class="function">fbsql_pconnect()</a></span> 返回的 FrontBase 链接标识符.</p>
<p class="para">如可选并未指定，函数会尝试查找一个到 FrontBase 服务器的开放链接，且如没有找到这样的链接，会尝试通过不带参数调用 <span class="function"><a href="fbsql_connect.html" class="function">fbsql_connect()</a></span> 来创建一个。</p>
</dd>

    
     <dt>
<code class="parameter">batch_size</code></dt>

     <dd>

      <p class="para">
      </p>
     </dd>

    
   </dl>

  </p>
 </div>


 <div class="refsect1 returnvalues" id="refsect1-function.fbsql-query-returnvalues">
  <h3 class="title">返回值</h3>
  <p class="para">
   <span class="function"><strong>fbsql_query()</strong></span> returns <strong><code>TRUE</code></strong> (non-zero) or <strong><code>FALSE</code></strong>
   to indicate whether or not the query succeeded.  A return value
   of <strong><code>TRUE</code></strong> means that the query was legal and could be executed by
   the server.  It does not indicate anything about the number of
   rows affected or returned. It is perfectly possible for a query
   to succeed but affect no rows or return no rows.
  </p>
  <p class="para">
   For SELECT statements, <span class="function"><strong>fbsql_query()</strong></span> returns a new
   result identifier that you can pass to <span class="function"><a href="fbsql_result.html" class="function">fbsql_result()</a></span>.
  </p>
  <p class="para">
   <span class="function"><strong>fbsql_query()</strong></span> will also fail and return <strong><code>FALSE</code></strong> if you
   don&#039;t have permission to access the table(s) referenced by the query.
  </p>
 </div>


 <div class="refsect1 examples" id="refsect1-function.fbsql-query-examples">
  <h3 class="title">范例</h3>
   <p class="para">
   The following query is syntactically invalid, so
   <span class="function"><strong>fbsql_query()</strong></span> fails and returns <strong><code>FALSE</code></strong>:
   <div class="example" id="example-1223">
    <p><strong>Example #1 <span class="function"><strong>fbsql_query()</strong></span> example</strong></p>
    <div class="example-contents">
<div class="phpcode"><pre><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">fbsql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT&nbsp;*&nbsp;WHERE&nbsp;1=1"</span><span style="color: #007700">)<br />&nbsp;&nbsp;&nbsp;&nbsp;or&nbsp;die&nbsp;(</span><span style="color: #DD0000">"Invalid&nbsp;query"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</pre></div>
    </div>

   </div>
  </p>
  <p class="para">
   The following query is semantically invalid if
   <em>my_col</em> is not a column in the table
   <em>my_tbl</em>, so <span class="function"><strong>fbsql_query()</strong></span>
   fails and returns <strong><code>FALSE</code></strong>:
   <div class="example" id="example-1224">
    <p><strong>Example #2 <span class="function"><strong>fbsql_query()</strong></span> example</strong></p>
    <div class="example-contents">
<div class="phpcode"><pre><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">fbsql_query&nbsp;</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT&nbsp;my_col&nbsp;FROM&nbsp;my_tbl;"</span><span style="color: #007700">)<br />&nbsp;&nbsp;&nbsp;&nbsp;or&nbsp;die&nbsp;(</span><span style="color: #DD0000">"Invalid&nbsp;query"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</pre></div>
    </div>

   </div>
  </p>
 </div>


 <div class="refsect1 seealso" id="refsect1-function.fbsql-query-seealso">
  <h3 class="title">参见</h3>
  <p class="para">
   <ul class="simplelist">
    <li class="member"><span class="function"><a href="fbsql_affected_rows.html" class="function" rel="rdfs-seeAlso">fbsql_affected_rows()</a> - Get number of affected rows in previous FrontBase operation</span></li>
    <li class="member"><span class="function"><a href="fbsql_db_query.html" class="function" rel="rdfs-seeAlso">fbsql_db_query()</a> - Send a FrontBase query</span></li>
    <li class="member"><span class="function"><a href="fbsql_free_result.html" class="function" rel="rdfs-seeAlso">fbsql_free_result()</a> - Free result memory</span></li>
    <li class="member"><span class="function"><a href="fbsql_result.html" class="function" rel="rdfs-seeAlso">fbsql_result()</a> - Get result data</span></li>
    <li class="member"><span class="function"><a href="fbsql_select_db.html" class="function" rel="rdfs-seeAlso">fbsql_select_db()</a> - Select a FrontBase database</span></li>
    <li class="member"><span class="function"><a href="fbsql_connect.html" class="function" rel="rdfs-seeAlso">fbsql_connect()</a> - Open a connection to a FrontBase Server</span></li>
   </ul>
  </p>
 </div>


</div></div></div></body></html>